﻿ALTER TABLE dbo.Collectors ADD
	[ThreadRecycleFrequencyMinutes] int NOT NULL CONSTRAINT DF_Collectors_ThreadRecycleFrequencyMinutes DEFAULT 1440,
	[NextRecycleTime] datetime NULL,
	[ThreadRecyclingEnabled] bit NOT NULL CONSTRAINT DF_Collectors_ThreadRecyclingEnabled DEFAULT 1
GO

Update Settings SET SettingValue = '3.1' WHERE SettingName like 'DatabaseVersion'
GO

print 'Also rerun the following scripts:'
print '  EventScavenger_SettingDefaults.sql'
print ' and'
print '  EventScavenger_StoredProcs.sql'